Previous Topic

Next Topic

Clearing old query results

Periodically, the interim tables used by iMIS reports and queries should be cleared of old data. You can accomplish this by running the sp_asi_ClearOldQueryResults script.

To clear old data from the query results tables

  1. From the iMIS Utilities menu, select Reports and Queries > Table Maintenance > Run ClearOldQueryResults Script.

    A message window opens and asks you to confirm that you want to run the script, and the Run ClearOldQueryResults script window opens.

  2. On the confirmation message window, click Yes.

    The script is run and the number of rows fitting the deletion criteria is reported in Run ClearOldQueryResults script window.

  3. On the Run ClearOldQueryResults script window, click Close.

    The Run ClearOldQueryResults script window closes.

See Also

Standard iMIS Reporting Capabilities

Using Standard iMIS Reporting Tools

Running a Standard Report

Modifying a Standard Report

Using Ad Hoc Searches

Cloning a Report (Permanent Report Modifications)

Printing Bar Codes

Exporting Report Data

Generating and Managing Mass Report Activity Records

Using the QuickLetter System for Letter Reports

Using the MS Word Letter System for Letter Reports


ASI logo 10.6 Production Release. Updated 2/20/2006 12:31:34 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.